SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985728 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985728 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180401,656676,184269,244276,951723,132223,936127,776919,700837,462616,594084,798888,287524,293494,132845,336820,475314,496846,442353,573383,894192,83530,904994,20898,673146,445860,446848,238073,795715,734229,696330,502132,81049,520714,995495,7606,683053,709248,913919,883524,515717,570914,711751,416544,657765,24571,254423,466860,501248,294741,220870,567158,316001,369581,520354,920496,724120,382164,69073,66676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]