SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509300 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509300 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774242,14459,888146,640762,935568,513102,984807,676364,263719,293261,359995,516685,690535,84796,125249,756641,470629,378786,718774,225627,397675,502232,940037,241100,124442,952573,675767,899305,244347,59579,61711,896090,940034,605050,943377,144874,426028,1047123,634658,116526,362506,295630,144385,105751,374379,771621,987330,464745,536468,460754,751131,877483,84402,341754,406547,637111,499530,512030,171027,1013938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]