SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68142 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68142 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10787,68836,689242,44098,453618,1042709,802411,218622,3025,239515,942595,62396,573136,890689,593776,1031412,1001862,568976,979976,491672,1025921,257252,754287,172245,173442,969645,195905,336277,167497,916634,563488,231066,1048681,274013,376293,249899,13776,314862,10685,936020,284444,523042,85039,1032475,398624,491820,376182,459318,197663,906533,5137,463499,474915,462746,13632,404045,982873,17300,454279,294928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]