SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504521 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504521 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927402,333874,642250,1045882,633980,993522,488880,369791,473006,142161,1031206,692153,739745,280762,32290,961971,79830,934914,667205,444286,825798,499959,630053,644560,99356,546866,846723,510531,880771,219105,836981,481858,803652,189126,236187,207639,876465,483526,703372,785092,21421,378767,329161,658483,949342,126588,662059,137413,339494,97631,626348,841306,122250,952120,1020851,495014,26545,145267,708383,920299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000772s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000816s ]