SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042173 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042173 [ RunTime:0.003043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875107,607838,101844,977874,601704,538578,203564,171844,24070,63942,201045,706640,153901,773631,477139,188330,701750,340800,427735,588358,101303,42587,234587,310229,9412,424362,850296,122454,862967,286930,359001,330483,289192,368534,477817,847211,566696,407838,968664,169926,251058,1021455,436429,516089,617485,672948,875194,627322,517014,555267,27913,349830,341527,741396,269180,302841,684135,884657,419415,238109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]