SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030109 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030109 [ RunTime:0.002092s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272709,172087,9266,1043324,991592,664172,681533,933309,838957,177157,535083,787188,583520,663088,180156,155464,534356,483263,575091,608136,431965,952290,165501,794925,506027,1008812,719489,690102,456408,693059,393628,696144,829214,808191,332628,996313,336940,477890,273060,475339,903713,618213,312242,481214,493274,264419,99396,904208,671708,626706,109024,356226,8987,614901,494703,448591,590490,1034012,565793,1013419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]