SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316035 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316035 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418047,211607,451737,939884,302107,638288,104007,435637,597220,386989,607801,594728,386136,937552,626814,409081,396901,413864,274953,836982,718542,503694,751335,843829,760418,743646,99910,470915,157801,352183,84264,595763,782798,725980,553681,50989,701354,503714,631168,10607,489972,142570,581830,202592,1032119,340497,409783,114725,450085,207344,975485,612035,561239,883842,1026132,433592,978485,645164,163350,939983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]