SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540560 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540560 [ RunTime:0.001293s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006831,901176,441963,561560,434828,465603,509834,900044,1024920,429717,528133,803568,8520,98020,258290,616301,205072,51104,920757,480623,854255,278721,541158,257243,278090,357283,776429,1020682,354843,861532,526742,974585,733405,202378,759739,503909,83254,475390,474204,55686,139067,280483,781012,1035287,321543,308237,41751,680003,855720,1038462,676963,379980,52307,195003,210984,389280,922115,757787,674473,1018156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]