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` = 404507 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404507 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731910,13269,284060,447011,787421,141232,581403,371271,72019,782491,970929,1037863,1028433,354756,782956,158852,880753,164860,719797,858221,154594,488681,136117,188417,863858,477707,101240,45740,544889,675384,283960,972632,933972,547971,768340,679857,759480,773315,244615,177595,157721,108613,304988,943042,928433,610843,825181,938288,788697,943369,619827,498781,180983,863785,125745,851967,424612,1010078,382616,905826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]