SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591781 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591781 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884433,658506,341518,330038,347681,472257,512063,3703,203207,936142,394565,181177,809823,454526,557189,790891,985434,292256,591048,686300,411185,894599,185572,270418,995778,328320,455354,753735,678897,567500,892981,33264,724842,82982,349904,523665,993798,216579,464942,547308,291708,211870,168898,844716,284837,79002,980410,758128,687557,465125,167833,720128,682481,164231,106774,572241,1015934,636963,283046,201381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]