SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104640 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104640 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026538,941694,962660,971180,75461,564214,428260,493638,634409,967247,1039991,683944,354221,949790,889801,544678,931572,49247,127082,171572,56331,696933,325196,219020,313419,530660,432742,37591,401599,642390,917458,251632,323748,408682,847643,627579,346833,701215,285795,358944,539793,664177,118042,913756,772027,933552,64036,992104,389316,658204,564402,701895,818622,250384,822590,634410,811795,177290,16613,959856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]