SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039161 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039161 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (977570,166657,473380,181071,623041,32134,769284,308974,48941,420807,943557,122727,453472,113675,120208,60422,995417,64237,1000226,326563,644786,606837,338086,359593,459504,348196,265061,1020734,514217,382641,995218,515507,628653,377544,756508,956069,665709,775853,753983,915471,283859,131639,752274,28385,874662,69159,161388,989678,1040964,991875,835717,385167,498780,464908,1041623,899272,715244,135159,233471,57048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]