SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544751 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544751 [ RunTime:0.005224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028436,591342,514203,992775,699714,367752,544423,1024811,293462,227844,291639,991466,782471,9123,417001,146962,721098,842988,884259,452094,526282,330914,863023,967113,757048,241567,543436,518149,400616,163948,424249,283846,842893,782533,115055,249860,654994,139123,672688,291146,372845,417281,105656,502834,365663,510565,879695,258523,1042507,538432,67859,455908,89629,564167,452840,675826,283202,987915,398224,654395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]