SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103187 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103187 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5400,432232,674100,651006,761757,214420,26647,689033,515991,510034,554952,345271,1042960,181908,150095,295193,38351,32019,385948,882825,713164,102474,334589,887664,775609,535265,864709,579282,36000,257402,596549,195291,585112,1026332,671802,585164,613959,757040,777082,921930,703351,200977,452810,935328,550939,790513,289466,421316,995237,327504,429830,838979,312029,782324,596225,248463,475865,558622,717059,791821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]