SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002059s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409151 LIMIT 1 [ RunTime:0.000554s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409151 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536732,922900,182232,327376,143410,522553,364985,265346,425310,709507,187873,183229,261061,113836,278312,491622,265322,177019,698198,876627,164082,631304,854671,676172,5208,5156,135250,406831,969729,41850,730257,888089,634857,466901,107747,903798,434105,82185,966565,267143,87593,687419,339456,137102,42869,850747,340141,767603,504093,909473,443574,621776,920776,730541,151023,904767,494742,777959,423620,406581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]