SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415652 LIMIT 1 [ RunTime:0.000571s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415652 [ RunTime:0.006084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997602,229762,1043335,181039,866645,897446,768285,568923,203038,706503,782718,67131,795643,524180,365165,98786,997465,43187,667671,997781,116461,1034079,397174,860959,988639,96049,527751,373284,226541,194346,810130,887427,740614,784656,744848,256046,45149,772604,249979,300097,118664,867779,406392,249719,874502,653562,1001701,553392,299727,729830,542651,484204,689972,336648,316532,181334,232001,611815,176747,155410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415652 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415652 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001014s ]