SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574581 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574581 [ RunTime:0.003934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184534,630404,1037598,269296,230265,475529,414124,230767,165862,859616,278040,76550,841575,328054,279535,316491,893651,257323,236165,344743,748296,361922,805687,170430,967929,531700,598846,579686,52952,710035,505780,30134,447027,618890,722228,252400,328307,957843,610696,232167,87144,581000,880933,515341,864566,899665,806521,380528,30164,267959,818358,289009,456992,25720,72648,455588,1019044,673392,291905,262537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001878s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]