SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345196 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345196 [ RunTime:0.002133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104053,436637,104064,192301,563531,326933,51732,1019586,793035,666959,164976,953986,272117,531738,214165,631450,228214,679854,190639,105484,942098,21530,511632,138544,983867,528281,789364,379113,353916,80978,949151,273312,863731,89147,970810,965897,665939,993169,421805,547803,849822,853641,752281,278315,362066,356775,802646,230770,213045,478708,146427,1031436,1044974,822880,520806,873999,304124,65830,351912,872307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]