SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53187 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53187 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874276,906504,369351,20003,737343,671849,540792,337420,884269,407050,298811,849000,5127,810702,491637,944099,832629,1009338,542301,755194,1030680,597194,702322,764755,363878,143792,426911,605265,378014,349251,733454,108750,839884,661204,709307,669487,331924,852764,630727,849264,841557,70292,779480,149995,29650,505608,281789,160924,872908,305302,465774,85502,876282,781018,447689,422428,742948,1035716,323086,847381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]