SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 9818 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 9818 [ RunTime:0.002539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460762,471786,94924,522323,575448,246682,31519,1044013,652399,197470,54961,183002,68488,127767,712154,1009813,83187,852485,1033146,457784,1021083,747800,408229,103968,653855,148752,1034329,30867,823948,903777,769504,153759,313645,22247,677401,202521,101853,569019,51245,485696,810019,777548,214566,2181,1024708,78219,34437,183909,55202,450720,42268,872676,1014758,758140,701748,1047314,1015371,719775,711072,789699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 9818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 9818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]