SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003555s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54312 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54312 [ RunTime:0.004788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91213,770543,776614,227651,491743,674990,111022,328547,636901,1020059,470936,329738,343648,780252,624102,392210,487850,599485,214428,1047641,768407,100030,177098,318748,679077,545973,474582,780655,278952,1030543,360787,701662,141703,154411,803330,993344,546124,641526,460133,853580,43597,254279,478374,520806,1008214,483273,844295,762485,445971,965118,855458,791355,879088,658198,562691,483866,590881,59024,569225,826837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001729s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]