SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022982 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022982 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189929,913204,20304,681960,17824,784143,978719,844266,887114,38090,708816,620416,361016,1027657,565581,249393,667655,11709,929416,912996,837848,945465,89588,863738,877827,489083,943452,59927,325959,143039,941223,396385,716794,776606,957471,564761,853454,587317,206202,297600,887580,478916,616487,571304,130280,481809,236153,24809,727778,728313,594966,96155,581075,294061,68207,409018,184166,169466,343860,230283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]