SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505703 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505703 [ RunTime:0.002986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71630,1039791,658341,92189,891451,38683,161056,887226,724582,331026,612405,432796,87509,1013243,307115,376370,297694,521126,263559,833914,383983,185391,864733,934049,854022,842964,469563,342620,371819,772399,1033653,649270,928828,715907,587059,210171,861668,768541,849144,371347,557649,934634,826443,556406,863094,134520,481754,890230,679182,554389,809966,1020804,125529,603895,834461,965548,1045133,314124,742272,913376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]