SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483951 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483951 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355565,298328,542359,979852,148198,531011,1019361,33038,220724,320625,633122,857653,740864,543792,996276,430719,552186,511594,62495,334961,216865,722010,313126,396543,442486,882887,245574,219040,379243,978042,883381,310852,112616,612370,267029,577493,1048489,1011261,546008,712457,180745,476436,806170,815821,502565,870314,318684,351629,678487,141896,449123,177835,267416,208897,65715,1018811,394475,983865,648626,214137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]