SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544812 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544812 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527889,225734,223736,211331,584974,920713,800766,552394,1026026,403285,456614,806252,529764,514695,25275,179263,556552,513306,847946,311527,898708,834111,73050,531735,586751,9104,795976,643976,705498,909267,515404,875585,1032025,826120,286448,254337,763946,583607,647915,132513,889740,721348,659019,478657,582273,613007,785698,470371,640258,449023,107993,212358,894144,450050,505453,610544,71857,562814,472311,817790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001015s ]