SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013309 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013309 [ RunTime:0.004516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597592,740853,680758,659971,560686,162318,212950,569545,852988,380853,1009286,888962,826147,899451,88920,863174,747992,392939,908354,603605,69247,125488,399241,369824,403937,236089,380745,363754,320839,251424,275405,281324,455006,464657,1037241,374180,716109,413696,308447,875509,195852,667360,91934,294849,899682,902655,992352,499266,925320,930587,498344,799456,150068,688745,143612,788489,533890,1034006,290964,896526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003064s ]