SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423708 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423708 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718121,664871,324527,671099,984044,30673,443516,495501,461332,478037,915404,636251,425373,752588,678493,578901,27291,743126,479132,797759,429880,971072,258432,740407,87057,32297,1029594,871900,718134,161976,767927,934907,911238,209224,85475,323148,706491,661305,366582,391536,1048512,881909,1001184,421596,527091,588737,58173,984968,581794,331647,569694,972902,943514,596235,919169,119640,161063,435234,288218,629892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]