SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293911 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293911 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612364,758190,883527,203762,1018322,443045,385619,468019,4645,759587,204898,491675,519037,628872,501442,149722,774255,434463,520905,561914,723005,1013103,48620,94411,560958,355464,993347,747267,1042935,379244,908278,1039841,952272,807174,505663,65054,437688,924337,866670,846500,863621,994886,301131,544098,192979,352559,679168,53607,221271,316157,250500,786070,933601,904754,170046,957060,176469,583110,424072,322193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000376s ]