SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510751 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510751 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894094,444459,606481,715191,969395,877209,412208,797074,1046377,905976,359110,220408,407486,386494,783849,14657,1032098,796475,416553,326761,291066,569658,943777,976207,1048177,537098,63527,1006357,1015737,79830,627698,473685,978540,888164,883171,123194,299715,49356,818577,919198,779950,807372,263215,1014598,904240,390074,777969,297809,928218,934912,378930,840670,52421,824852,494093,1043734,513758,184591,337446,248727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]