SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001909s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154568 LIMIT 1 [ RunTime:0.001060s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154568 [ RunTime:0.003876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517608,244430,675767,274135,20205,814113,231079,717997,810266,894525,417425,451243,460352,15134,285390,204945,351759,623329,697402,36874,1040415,924057,650305,49053,450527,638882,401478,73136,877062,234799,294473,89881,266497,252863,284068,157030,204277,492814,150405,822826,239883,1015474,612656,220593,801812,535322,967158,813122,739058,714458,257196,89637,3574,904875,782662,115500,546593,213214,931566,569011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002396s ]