SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409019 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409019 [ RunTime:0.002122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723765,368007,509376,354763,404007,101584,259397,587228,918520,547251,123303,508382,575610,913840,62657,972065,399476,499403,601669,590912,735531,989760,443256,254133,406215,140203,354135,690134,321869,890432,378508,768483,98791,841569,363814,455722,97001,745223,1024155,63898,601806,398695,912419,299419,836542,191001,739709,401431,905451,859999,284168,747141,18399,638397,399049,965204,769100,817044,798083,1000766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003978s ]