SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 855396 LIMIT 1 [ RunTime:0.000574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 855396 [ RunTime:0.003330s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013741,996489,921670,198491,477430,271488,318863,695564,98724,233523,660672,1033222,753043,835454,960537,632157,985468,734372,899944,900544,61423,851854,664044,1002993,807929,300082,223214,454917,614248,692176,243920,1002204,716335,988359,447460,928253,68183,478279,103344,783482,201767,150595,430284,638793,959296,176360,202549,222891,414194,104777,816902,739427,151390,273244,254642,625707,637636,579489,102178,810989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 855396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 855396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]