SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286011 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286011 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446363,209761,876474,444734,424203,344530,800630,1047920,807993,781593,350697,129458,944660,977230,68734,123309,664811,360416,343871,513231,824737,280193,560518,388011,79425,774719,703513,575755,805210,643488,485616,426259,521399,622433,181760,785097,71644,316444,129066,240460,78173,401947,555818,997894,297497,527920,339792,737509,773417,329897,41292,34968,682780,664398,785090,156939,974454,167018,1046220,319557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]