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` = 191368 LIMIT 1 [ RunTime:0.000639s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191368 [ RunTime:0.003544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511553,709438,344188,478389,696064,730845,961880,120320,371465,501063,24829,579565,580815,950623,749568,203562,776385,139175,310443,241923,569564,254191,883390,382806,937425,1001617,508566,420528,329584,916642,85144,973483,895194,259793,718299,336942,1025031,1034682,161812,543817,224906,281570,362483,152243,911748,369513,597469,187065,1046930,508709,64850,587303,536804,62605,1047204,425119,214755,601456,577414,289949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001545s ]