SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144571 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144571 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982593,538144,659654,615281,500977,622504,100911,565281,100177,327751,1015582,721372,1026884,14681,551227,1039404,773874,477701,139614,816001,593975,725850,461008,581669,988233,702715,218418,833931,61378,871669,478688,998624,56384,980681,350031,717069,130767,849415,745900,266631,904500,836361,482773,975613,161080,1006779,188899,659761,4449,414915,991342,92497,241090,937585,486864,899616,958038,78077,896754,477478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004569s ]