SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001821s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531053 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531053 [ RunTime:0.003386s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526963,276420,583984,749737,414805,481033,193264,633239,702258,115491,235017,888744,818475,399077,996515,377751,896226,20661,958749,119340,938125,136695,607687,750662,496256,790197,918457,697741,569606,102793,671986,753197,391992,507347,388601,531061,920912,933311,528671,748391,427456,485079,526614,996889,701614,800967,175823,525503,728514,458613,358229,920906,73322,991952,498397,802116,140574,40716,702452,761318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]