SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507417 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507417 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334389,486287,662950,223409,757645,923799,958793,271491,966351,471243,775036,316908,259525,893304,638326,775186,332441,604031,916139,301180,563283,704558,275952,514371,1026956,362840,7827,355390,372917,926172,226222,1021488,34225,923505,89817,519493,560997,335400,30548,489287,64331,1033248,866607,1044127,583390,188073,319619,691138,388941,797870,920339,689809,663613,605796,244377,300949,700298,721178,989677,707591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]