SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511098 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511098 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483372,251539,91828,502799,393823,761204,571593,547169,586363,1039132,218543,692754,337114,728893,590949,533231,38352,659139,264495,169043,252585,569271,420590,727349,639016,107693,542230,29783,213790,246761,428716,77272,480326,160727,393269,149102,864340,785241,371340,686656,383917,817289,1506,818195,464789,279709,562745,634612,415951,225611,677746,501833,239926,776034,397406,290131,454945,263651,156044,22455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]