SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40625 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40625 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348053,701796,853078,601985,380642,468220,612151,97787,301741,35493,369666,861411,534501,508236,851395,286751,299563,146635,24679,424006,1000508,661255,1020802,489151,229725,687175,732676,11332,909079,363830,792588,293542,1042094,736165,47947,636894,815896,124769,415632,541691,931332,438567,444970,413436,461170,350433,983324,559390,1006487,341008,915054,796348,127333,86412,372159,457153,585240,222128,1006397,805765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40625 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40625 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000876s ]