SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037732 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037732 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141727,511165,387683,548915,322358,791804,346020,316563,755115,161814,827754,248403,324586,1048507,186682,286203,981917,550929,888213,862871,74136,928343,284238,1025604,265423,342908,611487,675087,710166,40234,387433,569355,708050,617489,347938,847332,715308,850786,600005,810757,916260,1012007,308780,921101,1044139,525559,987540,1004867,397241,358623,68781,233581,738554,310309,944092,407411,106587,801037,750959,281338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037732 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037732 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]