SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573856 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573856 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99925,158023,142170,103819,60050,995097,300376,974041,663433,414256,1038919,834739,501270,1032845,252648,265125,313464,229055,364069,530785,699523,581161,441890,107297,948812,139741,98816,652177,575790,40013,473660,676095,303961,107654,814238,115863,177653,217650,832017,620791,400453,280906,43065,305013,236010,595917,359475,988073,471650,273018,840545,968028,598558,1027049,983104,354346,201088,291325,542492,211758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003608s ]