SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974318 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974318 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120782,269888,113067,290884,979067,987277,617511,521806,337820,981340,407071,877355,818696,257821,282171,77851,207811,248996,835792,540569,436134,247111,884209,515881,277374,71658,892388,721092,527450,932511,275711,1039888,915099,945408,877486,805486,295837,11712,275736,222810,480439,973110,1026432,53524,886997,138866,1048471,539881,169052,378517,760623,365116,340725,902113,773081,570627,1038239,33204,591524,190844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]