SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314288 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314288 [ RunTime:0.002475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274410,340890,237878,326979,366118,285312,100474,359225,2393,837076,567698,793873,199195,109915,786592,573849,431809,157348,416590,342616,273892,816683,275341,990487,912651,11275,872678,184572,7961,932220,715712,773693,516707,533575,11462,111530,807358,116114,909168,352091,295399,537853,932758,297377,771649,65931,805399,473839,531453,631134,664691,853099,329903,815464,70248,149547,344223,285604,709050,1028960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001035s ]