SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 122911 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 122911 [ RunTime:0.002605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014402,935111,909162,844452,827852,904274,753890,93152,231579,548818,627301,553834,678632,357278,240305,605857,683511,1002016,1046044,424349,737772,774835,559718,691946,244240,954181,293216,828212,1011584,834506,366535,341533,214993,810538,99540,784412,435611,408899,439914,826686,798382,225413,516216,700944,577251,1019091,545682,374604,179290,1037306,671426,500397,651251,1023665,415360,423012,172592,82708,99352,588038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 122911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 122911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]