SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014484 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014484 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030590,948971,321132,610831,118454,1021066,978552,540922,210863,34306,730503,472717,178873,443775,455312,509539,823723,687383,156249,716227,421494,26724,878262,361475,624195,86951,100269,320261,591070,52514,385434,408090,680740,410310,825589,302075,34429,1005814,852319,784628,261458,586830,286791,459031,968537,890617,495904,500147,388532,245798,712691,422104,442034,995044,1045157,760909,540416,983694,15006,758804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]