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` = 514516 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514516 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378338,302682,161714,1038772,470820,813964,640714,584165,242638,665043,885178,484161,110892,251409,709892,116835,796797,511918,352365,499178,308170,466356,791587,167099,736729,318767,596209,179805,347521,51100,456482,381054,786273,287461,876205,278452,152928,969741,681057,636959,1033543,1040116,52335,261154,960862,72681,119401,84918,659859,37846,293882,642594,964446,867412,566934,465463,781483,332954,27105,5953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]