SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002908s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424699 LIMIT 1 [ RunTime:0.001846s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424699 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866717,739397,638256,530576,923625,176283,473264,260887,38404,866039,911749,314829,455370,210297,755796,721112,389820,998970,903917,438102,130517,963740,108152,964910,866119,309693,76919,932895,97641,473570,395003,846985,159664,675012,907970,242306,411779,707213,292877,367519,630236,118109,703852,30603,80648,658651,24851,518946,221965,454210,253059,696760,179834,27824,791687,770200,815228,333459,535764,538241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]