SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001899s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 975008 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 975008 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953358,276469,403807,746374,1009912,144996,268292,390677,905494,258224,872130,725949,905514,887085,575828,461378,748670,943820,18082,388152,789572,124436,405288,88459,698696,850877,986897,748795,913747,617455,310847,705068,679583,485399,847464,266545,507743,657722,412718,1039101,848812,940911,783042,900689,666435,924791,941649,722901,553160,632069,824190,471721,438835,974490,149041,503766,973788,388383,912172,358479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 975008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 975008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]