SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001971s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002083 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002083 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576720,400067,324954,657163,536452,199560,417959,448384,118726,82855,608329,454708,768155,238243,1015416,527863,49220,358023,327084,321277,884259,234183,881101,319563,972915,2324,104644,837613,657400,599911,789919,942335,719931,379870,719678,343396,864995,576553,90933,509390,960237,267491,506370,663402,865854,583836,232358,769160,483783,1045657,263390,404029,653631,414604,564867,650940,335825,476251,866724,405664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001073s ]