SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 188996 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 188996 [ RunTime:0.002001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508591,180481,137641,506181,525805,225307,998486,726060,283646,382038,605709,916464,931130,1028935,79085,959534,112202,757388,178513,70473,582386,412253,412397,71631,334385,220012,980283,187083,893504,505556,411250,1019406,201250,837094,714,907058,456903,330003,436504,1001812,362398,308846,433000,748394,759991,1031733,394197,143370,441297,362969,245721,364203,814701,125018,397387,144705,8894,39720,961419,395798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 188996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 188996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]