SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841063 LIMIT 1 [ RunTime:0.001491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841063 [ RunTime:0.003089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500021,549367,986948,877896,97937,656542,642409,796636,1029875,115236,852213,265677,952698,208347,272013,1006376,1004212,1034928,191239,792178,131075,643767,228777,85349,620310,40019,719118,967353,503024,681429,1034186,639445,579204,847622,409482,306698,678090,384857,102504,162863,176704,76827,859776,53310,988553,463572,306555,669796,332634,35521,224168,300592,838493,6715,186868,463523,600288,293266,530907,123057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]