SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296415 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296415 [ RunTime:0.002660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385974,618841,419058,843946,342032,42475,1007131,248742,792451,705755,79141,1009612,297662,506653,1037673,929755,375306,931481,98157,1038408,503638,399748,615342,813271,558412,936757,697434,875476,527904,754522,1018713,1037429,67534,206353,793772,779294,349210,2467,403584,381340,835915,672709,933535,853026,592709,975378,980758,10433,544932,320083,790171,428295,378933,162797,473875,419553,396718,337337,355783,60143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]