SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418034 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418034 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046449,594576,348715,488001,783381,518935,792776,934113,489311,921732,996080,324619,448275,124412,919926,996410,644075,174143,279110,452224,679425,878568,394319,245708,988437,334558,134752,686920,803925,900388,927736,173696,457088,614987,832363,572460,486159,28096,640555,445720,93130,778023,586955,809883,443959,578203,872958,592896,761722,482525,489820,813562,458122,1042391,871184,959773,407339,365157,840765,73156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]