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` = 548073 LIMIT 1 [ RunTime:0.000506s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548073 [ RunTime:0.006050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82195,142381,386319,354269,334928,288811,428983,691829,260050,221725,60776,454293,423734,290257,640445,422644,442167,918650,922969,602892,398317,707069,961371,767243,945205,431894,262056,609808,962892,799137,649473,329199,965555,576250,406751,935089,345184,307540,548419,683724,300250,430226,783313,125034,106585,820168,586603,775502,565652,493155,680505,913924,477523,136644,843092,522392,13224,881330,262010,1041399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000772s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000735s ]