SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010211 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010211 [ RunTime:0.002691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765792,72277,992433,775052,249513,877443,354410,433843,233408,311189,477922,31227,361367,172220,664795,737392,168746,407986,130626,93721,770997,346501,87153,602584,202618,269494,604621,775863,902378,862094,685528,239910,418517,446101,608292,125531,380534,35000,695671,376802,174617,52551,11738,18523,146481,704945,353170,792812,769639,9052,384135,813163,749063,177392,533426,318583,477212,822718,778129,163469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]