SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405516 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405516 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288002,57249,429045,153072,1011970,27162,280877,98049,126192,41763,810688,332624,884453,87920,285584,94574,816296,876176,436502,598294,1031676,35177,764046,826353,495418,558147,812777,1018947,230004,803422,715630,720614,61080,789017,302036,933352,726988,877549,429608,195856,388269,1013902,507054,266162,1032690,6759,956379,705719,351432,271976,175681,602419,245061,879828,596854,1030844,645220,1047605,962046,1042233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]