SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440804 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440804 [ RunTime:0.001948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756827,980835,746625,918349,361224,958295,332000,409145,470252,112109,37487,847678,501538,378876,19873,75441,163874,148666,60556,120783,298129,379266,220111,480120,624957,861669,554066,351707,891461,179950,82042,680426,417067,183460,392952,209158,212700,220601,357030,229445,924823,323004,51735,155191,703507,66671,235439,366146,131238,99724,628449,908347,759786,285441,516363,413699,170070,462120,342958,176509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]