SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102518 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102518 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662246,589323,507678,230553,495588,1019502,644686,536568,507715,351300,484640,274334,706316,902824,467912,1001722,890042,57431,777530,590431,868809,36049,456962,142939,807384,631473,458545,628976,818896,326631,853941,246547,477125,306254,305376,112221,288288,188551,532513,288544,693319,839425,628800,505640,895700,81180,145858,1002577,540335,557386,268228,583786,947969,705428,775954,820111,829970,667679,451890,428302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]