SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416206 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416206 [ RunTime:0.002864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559693,496528,988475,855305,87728,469090,377681,371694,586313,1023832,540195,42970,641692,380621,649822,979638,815204,596580,554139,776222,618739,788111,415647,729045,471399,145574,517602,738529,420738,1023997,475042,817449,464835,667716,85335,798852,253955,620213,498523,53036,887228,870230,535972,615914,230202,1061,574126,328574,783765,194725,202976,969999,752387,375053,262562,395655,105844,903709,287877,280245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]