SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017650 LIMIT 1 [ RunTime:0.001296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017650 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995729,377241,1045415,79742,292220,547299,366773,815579,956453,785138,17620,539216,632413,809802,108944,106827,802460,375711,350210,624671,926032,15048,451188,969640,424217,957055,313003,338879,1015973,959177,121358,94240,481340,386223,81407,456681,1045018,864204,256666,722421,297816,663702,375426,229166,203617,955391,258859,139781,21317,384672,83360,801363,446694,845697,376516,638268,708777,1034707,720534,781040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]