SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002838s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804168 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804168 [ RunTime:0.006250s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323185,476214,190304,456519,564409,770581,443454,600987,497080,1017128,741643,847186,208828,705871,4814,620109,273132,401455,941556,840877,391526,164701,650210,342229,701614,28720,279876,461192,600842,836744,806535,958219,800030,76867,806814,1045792,822665,907580,734202,959148,407720,186919,121686,161501,55194,844215,221705,135267,741687,749109,950850,687370,406417,144177,158273,954369,462754,502874,425156,899294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804168 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804168 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]