SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340935 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340935 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329460,846654,660451,408903,14700,448584,842352,366650,241101,385555,916063,456505,104551,959511,215298,910639,216073,7716,696126,564671,965132,542239,308757,278100,251590,111695,421947,980235,107549,907103,983866,717863,753566,33554,460508,826135,710725,624951,415020,606760,175131,778348,699114,395924,49202,230040,365215,253850,196431,944678,380138,897545,204681,288155,558726,779929,657523,555436,486272,806580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]