SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044786 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044786 [ RunTime:0.002533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654520,612890,303114,389894,985189,113397,89414,591265,644428,467869,686474,347415,143254,978461,1007532,880515,283979,848602,634005,513535,436417,755463,927904,182546,928511,867208,370252,50036,86701,848970,873208,890572,1010367,50044,389126,904976,503298,723696,74368,36617,95955,855723,957995,542421,84023,698574,522825,174940,952535,4275,295339,707258,77181,893685,1039558,834947,36794,955641,377572,48874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044786 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044786 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]