SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424210 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424210 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190969,467460,515489,845504,872693,717079,39530,620608,913395,947304,327699,162901,694711,1002049,702122,448859,266608,858709,788490,611824,196970,146744,721407,409950,107789,467316,494328,999778,730116,678798,546705,322768,693746,706913,838233,498921,497756,407729,670069,202277,652672,799380,1034953,281197,624267,569622,190364,223080,419306,43322,453399,1031330,311226,425128,367483,347644,285495,202526,551364,255164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]