SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284851 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284851 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44139,705467,838836,513267,8225,342872,951517,35921,90488,212859,904015,906890,698179,548677,1035412,803701,812401,458212,734615,83746,650555,384636,392829,631852,369700,106804,96744,671432,564297,137422,401767,337300,37078,99824,422483,354388,476508,413606,5629,396193,1044146,396689,35227,950384,240118,487162,884977,712962,58343,91961,743021,599434,2203,625747,263273,88391,825470,126265,185232,107711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]