SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 923804 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 923804 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533464,953011,362916,405622,780451,960005,551002,958150,161708,466527,919157,41264,295268,862380,499066,715575,431088,4111,1048387,679437,409057,523117,255958,499221,1002904,372866,457289,255800,175718,1012488,171248,964292,24960,748593,1042768,394494,115935,263758,917776,935801,322900,1000244,603032,939456,1013200,365325,556884,820282,76458,782133,435398,346749,16424,687352,180256,784307,262342,850853,731806,353210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 923804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 923804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]