SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003689s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541200 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541200 [ RunTime:0.003096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311861,158249,741351,854529,562027,652086,763059,850015,84191,696969,546594,9898,652481,263127,348720,814458,554219,23077,1008773,225080,160162,214254,287038,986180,312962,343001,1019764,750475,967800,517104,619520,353344,325055,174084,162179,480158,856561,406441,15647,113787,580196,96864,588005,632229,631044,624626,680333,827162,614668,97515,56860,835198,302317,852660,238373,793263,994162,834063,968991,865788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]