SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449856 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449856 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542791,565043,522862,764157,271190,806943,73904,77755,586037,877290,108522,370788,596082,803092,657570,226227,12096,222796,594966,826198,750157,907122,916543,66693,760742,583760,782935,389034,503206,982766,625738,611025,679506,34762,823826,658908,21101,588474,335771,872465,743896,543635,969378,113353,725225,351006,30575,531115,435634,228249,854086,309099,1031112,707922,567575,1007819,244252,491528,155209,496017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]