SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102852 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102852 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320019,270389,951647,1025188,968967,696039,21706,507603,173281,823865,794642,335525,41615,548445,642773,132087,350945,772951,970136,276969,220822,362087,102314,846911,32817,141283,909436,886161,648033,566132,496763,510283,1018184,477046,810659,139773,986892,612088,567108,767626,555258,467142,783689,749056,186746,968098,881040,828197,584269,251289,866686,201519,53517,897626,705943,554176,7755,955653,685533,992968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102852 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102852 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]