SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446581 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446581 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613920,568927,785910,425768,404232,63634,155677,713234,1041278,879594,1036823,720079,592097,341313,1001912,464343,715400,994875,764371,408897,234022,362050,1037192,654071,317883,47638,44339,207606,784379,928040,93396,586217,104335,547307,879190,624275,702313,387888,595610,842496,212009,476914,793779,102061,900729,696169,263216,659947,16201,508685,707900,582618,759801,390992,792838,724773,499822,600902,1019021,479531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]