SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001587s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560083 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560083 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425353,635081,99716,986147,771195,490314,983418,82636,354064,728809,880515,346373,192483,222834,795876,88246,514270,982531,490958,692538,124072,808760,25826,814842,87316,401158,378373,226962,671830,88538,1009299,179432,158787,540021,1045276,890075,521980,926867,645776,995059,987717,676590,348574,435224,389495,603263,200816,462094,539784,48141,319540,644457,978397,699945,617425,982826,677908,725967,523793,728607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]