SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292640 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292640 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830529,891916,315220,63854,261113,9412,345416,818082,963475,461745,150045,124053,731184,346745,783697,1042335,689806,925010,617919,705854,554486,1028051,72388,354882,235056,11082,287477,931933,153983,337559,478490,716580,955644,869829,52957,821050,644107,912606,726340,174496,99634,1034519,782663,350946,757712,409178,409894,250307,978390,685710,127933,228776,961211,208238,82570,679397,737580,458967,75178,1038528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001422s ]