SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048804 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048804 [ RunTime:0.002579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634474,904038,604907,169201,998283,845981,968621,431867,71003,248876,94724,731353,979768,251040,412321,559477,525254,241889,127692,913038,631528,1027109,390581,105298,764256,43500,210945,811641,807364,768746,956034,1003559,291901,236356,442943,854608,871139,762360,42559,230837,806077,995898,522147,393434,614713,483360,54445,201895,342961,553246,42003,221723,979770,420488,492626,411791,782423,451375,206657,341258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]