SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315801 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315801 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449034,433076,390257,1036143,108528,332112,102629,905253,294456,122437,477433,254498,952498,849918,99295,463916,971545,305804,84890,996621,910310,941431,121379,408384,409973,946016,301385,126238,1043184,553213,667410,1041579,520424,360452,375078,103762,164361,770335,242908,128904,432931,263970,213976,405606,578142,177110,981802,401405,878527,290916,818696,438066,284219,320299,563020,541860,788457,332823,23790,64883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]