SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 208698 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 208698 [ RunTime:0.002456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006294,1026354,779864,249171,383291,46199,501545,108253,153494,86618,811271,131280,811626,28921,582345,813858,870331,1013243,473202,183617,796441,238086,758764,773411,843047,33739,885833,439617,642322,46053,294035,750972,587543,490741,251938,269138,53287,768493,850851,112341,473156,784878,1013588,729580,506108,879836,100839,708388,34669,415363,240668,631353,59387,630898,16824,147444,955328,434287,536216,891548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 208698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 208698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]