SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020268 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020268 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525249,175458,706889,863279,793174,766018,707114,174150,301151,917544,716260,619995,280253,718027,281152,686901,937775,352133,563193,532121,1026397,378750,103470,726612,865452,909767,393374,197652,556179,382708,5739,655715,709561,466994,125911,473716,417305,390751,295032,667809,767080,620848,893308,648619,565594,922683,632933,151676,441641,54255,515757,610702,61461,430469,181514,445915,975581,929532,519771,357484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020268 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020268 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]