SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 270071 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 270071 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413050,1010533,206510,409184,815118,346726,653364,725045,406764,111039,241900,253788,916012,732063,860140,784273,324490,994036,551914,665939,850587,796729,865601,460347,22695,771437,782175,340901,819870,243738,853644,391845,987984,947703,815416,773003,629587,347481,575393,767486,167637,124235,195408,306485,278658,582246,687987,530803,55585,859476,293705,776479,691030,249937,746555,612795,71777,10848,461182,802003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 270071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 270071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]