SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 902881 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 902881 [ RunTime:0.002616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411268,711287,563598,890952,183468,312398,235388,495224,340755,916710,909845,485905,1044974,92656,775222,877460,630599,421463,671559,942930,522823,169268,348368,517423,361023,993218,111897,487829,345370,1034160,471810,398934,324000,118117,518089,34402,481702,11401,365022,707963,728774,638262,340066,336837,731783,653769,709644,171774,602387,867677,112835,426730,669183,306528,665783,188764,168079,792975,916979,376229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 902881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 902881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]