SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002858s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501329 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501329 [ RunTime:0.003808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866775,209008,184883,1022561,889233,657624,566466,698020,975513,253080,454698,637386,936312,850666,139877,622839,350397,460052,978986,143649,791838,11923,101403,396017,889098,38251,860099,221724,33781,886900,27743,472191,813282,267365,658747,770144,875140,983362,1026932,568530,112495,211489,118989,377323,422733,782584,789271,287136,790119,919219,114611,62270,588127,190516,342106,802717,675730,635348,58663,972436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]