SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019044 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019044 [ RunTime:0.003111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512626,778040,794542,193914,740824,330566,166993,173113,849660,845009,438577,367157,758811,157740,112611,592029,122563,361527,880428,545204,512056,814836,82477,780023,266293,13358,950876,101982,744726,408077,658471,177543,457873,651160,530268,427466,571182,531067,621545,82870,281008,1036356,24705,877136,832608,302089,526683,607314,352620,482639,994746,1026212,934786,166502,291515,169106,554309,486294,823041,265559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]