SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500014 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500014 [ RunTime:0.003196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923414,769341,915068,495441,374669,161986,159376,520905,151670,99834,172860,844398,602946,626501,1022330,341830,286980,420535,30792,109353,357130,823070,431366,527634,964047,43625,704659,354303,540130,754822,439108,1013471,94927,125918,426230,234919,304205,816117,215696,1047955,986952,191109,826650,242661,587237,556934,453866,157312,271801,280922,1018922,786044,182904,363695,445382,154780,741939,240650,333528,938135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]