SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591981 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591981 [ RunTime:0.002430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81308,15744,306884,149463,325079,438164,459974,264034,654207,236614,750659,457284,640954,439784,355807,211650,899606,316355,957077,144995,369188,372788,688568,609324,290408,803063,375733,541278,669671,616303,169048,1034120,37324,102453,186590,245493,954286,762676,605781,844135,1004036,553688,542642,979039,1001482,955634,486942,132713,994424,273010,475966,570354,289167,1008013,176669,849761,45090,586684,75258,652326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]