SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 73178 LIMIT 1 [ RunTime:0.001471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 73178 [ RunTime:0.001940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480177,150063,783126,421215,433902,36076,152042,387299,201330,47205,520719,351020,139879,22161,991430,443669,403476,802090,882064,652000,341461,68751,477454,291152,122836,707577,445551,222353,654922,808087,409893,427102,953747,108251,788087,304533,1003925,512622,282523,390970,199377,420600,876973,320010,269572,36131,860166,1014445,732414,269846,229059,804087,346216,296611,628158,201688,328758,310756,408583,579143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 73178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 73178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]